﻿CREATE TABLE t_moon_user  (
  Id varchar(32) PRIMARY KEY,
  Account varchar(100),
  Password varchar(100),
  NickName varchar(100),
  Mobile varchar(32),
  Email varchar(32),
  Expire varchar(32),
  Flag int,
  Icon varchar(255),
  UserType int,
  CreateDate datetime,
  CreatorId varchar(50),
  ModifyDate datetime,
  Modifier varchar(50),
  Version varchar(50)
);

CREATE TABLE t_moon_user_role  (
  Id int IDENTITY PRIMARY KEY,
  UserId varchar(32),
  RoleId varchar(32)
);

CREATE TABLE t_moon_role  (
  Id int IDENTITY PRIMARY KEY,
  RoleCode varchar(50),
  RoleName varchar(50)
);        

CREATE PROCEDURE [dbo].[Proc_Test]
	@code varchar(20),
	@name varchar(20) output
AS
BEGIN
	set @name = 'sqlserver proc';
	select 'sqlserver dapper.moon';

	select top 10 * from t_moon_user;
END